{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Costs & Service Life","Effectiveness (CRF)","MISC"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":235,"n_cols":131,"rows_kept":235,"cut":false,"hidden":false,"merged":[[0,1,1,17],[8,107,9,107],[8,108,9,108],[8,109,9,109],[8,100,9,100],[8,101,9,101],[8,102,9,102],[8,103,9,103],[8,104,9,104],[8,95,9,95],[8,96,9,96],[8,97,9,97],[8,98,9,98],[8,99,9,99],[8,105,9,105],[8,106,9,106],[8,90,9,90],[8,91,9,91],[8,92,9,92],[8,93,9,93],[8,94,9,94],[8,85,9,85],[8,86,9,86],[8,87,9,87],[8,115,9,115],[8,116,9,116],[8,117,9,117],[8,118,9,118],[8,119,9,119],[8,110,9,110],[8,111,9,111],[8,112,9,112],[8,113,9,113],[8,114,9,114],[8,125,9,125],[8,126,9,126],[8,127,9,127],[8,128,9,128],[8,130,9,130],[8,120,9,120],[8,121,9,121],[8,122,9,122],[8,123,9,123],[8,124,9,124],[8,129,9,129],[8,88,9,88],[8,89,9,89],[8,80,9,80],[8,81,9,81],[8,82,9,82],[8,83,9,83],[8,84,9,84],[8,75,9,75],[8,76,9,76],[8,77,9,77],[8,78,9,78],[8,79,9,79],[8,70,9,70],[8,71,9,71],[8,72,9,72],[8,73,9,73],[8,74,9,74],[8,65,9,65],[8,66,9,66],[8,67,9,67],[8,68,9,68],[8,69,9,69],[8,60,9,60],[8,61,9,61],[8,62,9,62],[8,63,9,63],[8,64,9,64],[8,58,9,58],[8,59,9,59],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[87,10,87,11],[3,1,53,1],[18,5,18,9],[16,5,16,7],[26,10,26,12],[26,8,26,9],[27,8,27,9],[57,8,57,9],[162,1,232,1],[163,3,163,19],[171,3,171,19],[164,3,164,19],[231,10,231,11],[54,1,88,1],[65,3,65,19],[89,1,161,1],[87,3,87,9],[92,3,92,19],[90,3,90,19],[55,3,55,19],[160,10,160,11],[100,3,100,19],[2,1,2,19],[5,4,5,8],[10,4,10,5],[11,4,11,5],[5,10,5,12],[5,14,5,16],[31,14,31,19],[36,11,36,12],[8,42,9,42],[36,8,36,9],[36,4,36,7],[33,4,33,6],[8,43,9,43],[8,49,9,49],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,23,9,23],[8,24,9,24],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,25,9,25],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48]]}
[null,"Wild Animal Benefit-to-Cost Spreadsheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Editable cells"]
[null,"This Excel spreadsheet was developed using CDOT resources and provides the assumptions, methodologies, and backup calculations for the benefit-to-cost analysis for the Wildlife Prioritization Study. This spreadsheet should be utilized for planning only. The calculations do not provide automatic approval for grant funding and/or safety funding. Requests for grant funding and safety funding will still need to be completed through the process governed by DTD and the Traffic & Safety Engineering Branch, respectively."]
[null,"User Form"]
[null,null,null,"Project Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,"The scope of work below will be completed along State Highway",null,null,null,null,null,"beginning at mile post",null,null,null,"and ending at mile post",null,null,null,".",null,null,null,{"$f":"ROW()","v":6},"Discount Year",{"$f":"IF(N27=\"one (1) year\",0,1)","v":1},{"$f":"Y6+1","v":2},{"$f":"Z6+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,null,null,null,{"$f":"BD6+1","v":33},{"$f":"BH6+1","v":34},{"$f":"BI6+1","v":35},36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,{"$f":"DU6+1","v":99},100,101,102]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":8},"Project Year",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,{"$f":"BD8+1","v":31},{"$f":"BH8+1","v":32},{"$f":"BI8+1","v":33},34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,{"$f":"DU8+1","v":97},98,99,100]
[null,null,null,"Project Scope & Estimated Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Fiscal Year",{"$f":"IF(Y6=0,\"\",I27)","v":0},{"$f":"IF(Y9=\"\",I27,Y9+1)","v":1},{"$f":"Z9+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"DTD Discounted Maintenance","WVC Discounted Maintenance","Residual Cost",{"$f":"BD9+1","v":32},{"$f":"BH9+1","v":33},{"$f":"BI9+1","v":34},35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,{"$f":"DU9+1","v":98},99,100,101,"DTD Discounted Residual","WVC Discounted Residual"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E11,'Costs & Service Life'!$B$6:$I$28,5,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E11,'Costs & Service Life'!$B$6:$I$28,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(ISNUMBER(SEARCH(\"pass\",INDIRECT(\"E\"&ROW()))),(LEFT(INDIRECT(\"H\"&ROW()),FIND(\"x\",INDIRECT(\"H\"&ROW()))-1)*1)*(RIGHT(INDIRECT(\"H\"&ROW()),LEN(INDIRECT(\"H\"&ROW()))-FIND(\"x\",INDIRECT(\"H\"&ROW())))*1),INDIRECT(\"H\"&ROW()))*INDIRECT(\"L\"&ROW()),\"\")","v":""},null,{"$f":"IF(E11=\"\",\"\",IFERROR(N11*0.01,\"\"))","v":""},null,{"$f":"IF(N11=IFERROR(IF(ISNUMBER(SEARCH(\"pass\",E11)),(LEFT(H11,FIND(\"x\",H11)-1)*1)*(RIGHT(H11,LEN(H11)-FIND(\"x\",H11))*1),H11)*L11,\"\"),\"\",\"Estimated Cost Overrode by User\")","v":""},null,null,null,null,{"$f":"ROW()","v":11},"Undiscounted Maintenance",0,0,{"$f":"IF(AA$8<=$J11,$P11/$J11,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(AB$8<=$J11,$P11/$J11,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF($Y$6=1,NPV($H$112,Y11:BD11),NPV($H$112,Z11:BD11))","v":{"$error":"#VALUE!"}},{"$f":"IF($Y$6=1,NPV($H$183,Y11:BD11),NPV($H$183,Z11:BD11))","v":{"$error":"#VALUE!"}},{"$f":"IF(J11>30,(J11-BD$8)/J11*N11,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(BH$8<=$J11,$BG11/(1+$H$183)^(BH$6),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(CN$8<=$J11,$BG11/(1+$H$183)^(CN$6),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(DT$8<=$J11,$BG11/(1+$H$183)^(DT$6),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"SUM(BH11:DY11)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Mitigation Item",null,null,{"$f":"IF(ISNUMBER(SEARCH(\"pass\",E11)),\"span (ft) by width (ft)\",IF(ISNUMBER(SEARCH(\"Fencing\",E11)),\"length\"&IF(ISNUMBER(SEARCH(\"mile\",E11)),\" (mi)\",\" (ft)\"),\"count\"))","v":"count"},null,"Service Life (years)",null,{"$f":"\"Unit Cost\"&IF(ISNUMBER(SEARCH(\"pass\",E11)),\" ($/ft2)\",IF(ISNUMBER(SEARCH(\"mile\",E11)),\" ($/mi)\",IF(ISNUMBER(SEARCH(\"feet\",E11)),\" ($/ft)\",\" ($ each)\")))","v":"Unit Cost ($ each)"},null,"Estimated Cost ($)",null,"Maintenance Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J11>30,(J11-BD$8)/J11*N11,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(BH$8<=$J11,$BG12/(1+$H$112)^(BH$6),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(CN$8<=$J11,$BG12/(1+$H$112)^(CN$6),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(DT$8<=$J11,$BG12/(1+$H$112)^(DT$6),0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"SUM(BH12:DY12)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":14},"=IFERROR(IF(ISNUMBER(SEARCH(\"pass\",INDIRECT(\"E\"&ROW()))),(LEFT(INDIRECT(\"H\"&ROW()),FIND(\"x\",INDIRECT(\"H\"&ROW()))-1)*1)*(RIGHT(INDIRECT(\"H\"&ROW()),LEN(INDIRECT(\"H\"&ROW()))-FIND(\"x\",INDIRECT(\"H\"&ROW())))*1),INDIRECT(\"H\"&ROW()))*INDIRECT(\"L\"&ROW()),\"\")"]
[null,null,null,null,{"$f":"SUM(N9:N14)","v":0},"Mitigation Subtotal"]
[]
[null,null,null,null,{"$f":"E15*F17","v":0},0.3]
[]
[null,null,null,null,{"$f":"SUM(E15:E17)*F19","v":0},0.221]
[]
[null,null,null,null,{"$f":"SUM(E15:E19)","v":0},"Total Costs"]
[]
[null,null,null,null,{"$f":"SUM(P9:P14)","v":0},"Maintenance Costs (assumed at 1% of the mitigation subtotal)"]
[]
[null,null,null,"Construction"]
[]
[null,null,null,null,"The construction of the proposed improvements will begin in",null,null,null,null,null,"and will be completed in"]
[null,null,null,null,null,null,null,null,"Year",null,null,null,null,"Choose one"]
[]
[null,null,null,"Effectiveness (Crash Reduction Factor)"]
[]
[null,null,null,null,"Based on the scope of the project provided above, the best fit Mitigation Item & Target Specifics (see 'Effectiveness (CRF)' tab) is: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":32}]
[]
[null,null,null,null,"The crash reduction factor is as follows:",null,null,{"$f":"IFERROR(VLOOKUP(INDIRECT(\"O\"&CRFRow),'Effectiveness (CRF)'!$B$7:$E$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDIRECT(\"O\"&CRFRow),'Effectiveness (CRF)'!$B$7:$E$9,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(INDIRECT(\"O\"&CRFRow),'Effectiveness (CRF)'!$B$7:$E$9,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"=IFERROR(VLOOKUP(INDIRECT(\"O\"&CRFRow),'Effectiveness (CRF)'!$B$7:$E$9,2,FALSE),\"\")"]
[null,null,null,null,null,null,null,"Fatal",null,"Injury",null,"Property Damage Only (PDO)"]
[null,null,null,"Crash History"]
[null,null,null,null,"The crash history for the location above was reviewed from",null,null,null,null,null,"to",null,null,"and the observed crash counts are as follows:"]
[null,null,null,null,null,null,null,null,"From Date",null,null,"To Date"]
[]
[null,null,null,null,null,"Fatal"]
[]
[null,null,null,null,null,"Injury"]
[]
[null,null,null,null,null,"PDO"]
[]
[null,null,null,null,null,"Deer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,"Elk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($V$46:$V47)+1","v":2}]
[]
[null,null,null,null,null,"Pronghorn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($V$46:$V49)+1","v":3}]
[]
[null,null,null,null,null,"Bighorn Sheep",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX($V$46:$V51)+1","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"ROW()","v":54}]
[null,"Traffic & Safety Engineering"]
[null,null,null,"Disclaimer: This Excel spreadsheet provides the assumptions, methodologies, and backup calculations for the benefit-to-cost analysis for the Wildlife Prioritization Study. This spreadsheet should be utilized for planning only. The calculations do not provide automatic approval for Highway Safety Improvement Program (HSIP) nor FASTER Safety Mitigation (FSM) program funding. Requests for funding will need to be completed as outlined by each program. Please contact the Traffic & Safety Engineering Branch for additional information."]
[null,null,null,"Based on the national consumer price index (CPI) and employer cost index (ECI), the Traffic & Safety Engineering Branch developed crash costs values for economic analysis. These values are updated "]
[null,null,null,"annually. The following costs per severity level are effective as of:",null,null,null,null,"2021-07-01"]
[]
[null,null,null,null,null,"Fatal",null,1820600]
[]
[null,null,null,null,null,"Injury",null,101800]
[]
[null,null,null,null,null,"PDO",null,11100]
[]
[null,null,null,"The Traffic & Safety Engineering Branch method for calculating benefit-to-cost for safety projects is as follows:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":66}]
[]
[null,null,null,null,null,"Interest Rate (i):",null,0.05,null,"The Traffic & Safety Engineering Branch assumes an interest (or discount rate) of 5%."]
[]
[null,null,null,null,null,"Annual Daily Traffic Growth Rate (a):",null,0.02,null,"The Traffic & Safety Engineering Branch assumes an annual daily traffic growth rate of 2%."]
[]
[null,null,null,null,null,"Weighted Service Life (L):",null,{"$f":"IFERROR(IF(SUMPRODUCT($J$9:$J$14,$N$9:$N$14)/SUM($N$9:$N$14)>20,20,SUMPRODUCT($J$9:$J$14,$N$9:$N$14)/SUM($N$9:$N$14)),0)","v":0},null,null,null,"NOTE: The Traffic & Safety Engineering Branch uses a maximum useful service life of 20 years."]
[]
[null,null,null,null,null,"Year Factor (N):",null,{"$f":"YEARFRAC($I$37,$L$37,1)","v":0},null,"The number of years of crash history reviewed/analyzed."]
[]
[null,null,null,null,null,"Capital Recovery Factor (β):",null,{"$f":"IFERROR((H68*(1+H68)^H72)/((1+H68)^H72-1),0)","v":0}]
[]
[null,null,null,null,null,"Average Annual Fatal Crash (F):",null,{"$f":"IFERROR(($H$40*(1+H70)^(H72/2))/H74,0)","v":0}]
[]
[null,null,null,null,null,"Average Annual Injury Crash (I):",null,{"$f":"IFERROR(($H$42*(1+H70)^(H72/2))/H74,0)","v":0}]
[]
[null,null,null,null,null,"Average Annual PDO Crash (P):",null,{"$f":"IFERROR(($H$44*(1+H70)^(H72/2))/H74,0)","v":0}]
[]
[null,null,null,null,null,"Annual Maintenance Cost (AMC):",null,{"$f":"IFERROR(SUMPRODUCT(1/J9:J14,P9:P14),0)","v":0}]
[]
[null,null,null,null,null,"Benefit-to-Cost Ratio (B/C):",null,{"$f":"IFERROR(SUM(H64*H82*L34,H62*H80*J34,H60*H78*H34)/(E21*H76+H84),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":87}]
[null,null,null,"Based on the information provided above, the T&S calculated benefit-to-cost ratio is:",null,null,null,null,null,null,{"$f":"H86","v":0}]
[]
[null,"Division of Transportation Development (DTD)"]
[null,null,null,"Disclaimer: This Excel spreadsheet provides the assumptions, methodologies, and backup calculations for the benefit-to-cost analysis for the Wildlife Priorizitation Study. The methodology follows TIGER and FASTLANE guidance. This spreadsheet should be utilized for planning only. The calculations do not provide automatic approval for any grant funding. Requests for grant funding will still need to be completed through the process governed by DTD."]
[null,null,null,"Benefit-Cost Analysis Guidance Publication:",null,null,null,2021]
[null,null,null,{"$f":"\"The monetized crash costs (below) were developed based on the \"&H92&\" U.S. Department of Transportation's Benefit-Cost Analysis Guidance for Discretionary Grants.\"","v":"The monetized crash costs (below) were developed based on the 2021 U.S. Department of Transportation's Benefit-Cost Analysis Guidance for Discretionary Grants."}]
[]
[null,null,null,null,null,"Fatalitiy Value",null,12071000]
[]
[null,null,null,null,null,"Injury Value (severity unknown)",null,284100]
[]
[null,null,null,null,null,"PDO cost per vehicle",null,4500]
[]
[null,null,null,"The monetized value of wildlife are as follows:"]
[null,null,null,null,null,{"$f":"\"Value of \"&F46","v":"Value of Deer"},null,2178]
[]
[null,null,null,null,null,{"$f":"\"Value of \"&F48","v":"Value of Elk"},null,2537]
[]
[null,null,null,null,null,{"$f":"\"Value of \"&F50","v":"Value of Pronghorn"},null,2106]
[]
[null,null,null,null,null,{"$f":"\"Value of \"&F52","v":"Value of Bighorn Sheep"},null,7533]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":110}]
[]
[null,null,null,null,null,"Discount Rate (i):",null,7.0000000000000007E-2,null,"The Division of Transportation Development uses a 7% discount rate per grant application.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":112}]
[]
[null,null,null,null,null,"Annual Daily Traffic Growth Rate (a):",null,1.2E-2,null,"The Division of Transportation Development assumes an annual daily traffic growth rate of 1.2%."]
[]
[null,null,null,null,null,"Weighted Service Life (L):",null,{"$f":"IFERROR(IF(SUMPRODUCT($J$9:$J$14,$N$9:$N$14)/SUM($N$9:$N$14)>30,30,SUMPRODUCT($J$9:$J$14,$N$9:$N$14)/SUM($N$9:$N$14)),0)","v":0},null,null,null,"NOTE: The Traffic & Safety Engineering Branch uses a maximum useful service life of 20 years."]
[]
[null,null,null,null,null,"Year Factor (N):",null,{"$f":"YEARFRAC(I37,L37,1)","v":0},null,"The number of years of crash history reviewed/analyzed."]
[]
[null,null,null,null,"Note: The following calculations assumes that construction will begin in FY 2019 and take 1 year to complete."]
[]
[null,null,null,null,null,{"$f":"\"Predicted Fatal Crash Counts\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (F):\"","v":"Predicted Fatal Crash Counts (F):"},null,{"$f":"IFERROR(($H$40*(1+H114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted Injury Crash Counts\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (I):\"","v":"Predicted Injury Crash Counts (I):"},null,{"$f":"IFERROR(($H$42*(1+H114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted PDO Crash Counts\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (P):\"","v":"Predicted PDO Crash Counts (P):"},null,{"$f":"IFERROR(($H$44*(1+H114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F46&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V46&\"):\"","v":"Predicted Deer Deaths (W1):"},null,{"$f":"IFERROR(($H46*(1+$H$114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F48&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V48&\"):\"","v":"Predicted Elk Deaths (W2):"},null,{"$f":"IFERROR(($H48*(1+$H$114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F50&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V50&\"):\"","v":"Predicted Pronghorn Deaths (W3):"},null,{"$f":"IFERROR(($H50*(1+$H$114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F52&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V52&\"):\"","v":"Predicted Bighorn Sheep Deaths (W4):"},null,{"$f":"IFERROR(($H52*(1+$H$114)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":136}]
[null,null,null,null,null,"Undiscounted Crash Reduction Benefit (UB):",null,{"$f":"IFERROR(((1+H114)^H116-1)/H114*SUM(H122*H95*$H$34,H124*H97*$J$34,H126*H99*$L$34)/H118,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Year",0,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal Year",2019,null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,null,null,null,null,"Undiscounted Benefit Value of Wildlife (UBW):",null,{"$f":"IFERROR(((1+$H$114)^$H$116-1)/$H$114*SUMPRODUCT($H$102:$H110,$H$128:$H136)*$L$34/$H$118,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UB",0,null,{"$f":"IF(AA137<=$H$116,SUM($H$95*$H$122,$H$97*$H$124,$H$99*$H$126),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Discounted Crash Reduction Benefit (DB):",null,{"$f":"IFERROR(NPV(H112,Y140:BD140)/H118,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBDE",0,null,{"$f":"IF(AA137<=$H$116,SUM($H$102*$H$128,$H$104*$H$130),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"Discounted Benefit Value of Wildlife (DBW):",null,{"$f":"IFERROR(NPV(H112,Y141:BD141)/H118,0)","v":0}]
[]
[null,null,null,null,null,"Discounted Residual Cost:",null,{"$f":"IFERROR(SUM(DZ11:DZ14),0)","v":0}]
[]
[null,null,null,null,null,"Total Discounted Benefit:",null,{"$f":"SUM(H141,H143,H145)","v":0}]
[]
[null,null,null,null,null,"Undiscounted Construction Costs (UC):",null,{"$f":"E21","v":0}]
[]
[null,null,null,null,null,"Undiscounted Maintenance Costs (UM):",null,{"$f":"E23","v":0}]
[]
[null,null,null,null,null,"Discounted Construction Costs (DC):",null,{"$f":"IF(N27=\"one (1) year\",H149/(1+H112)^1,SUM(H149/2/(1+H112)^1,H149/2/(1+H112)^2))","v":0}]
[]
[null,null,null,null,null,"Discounted Maintenance Costs (DM):",null,{"$f":"IFERROR(SUM(BE11:BE14),0)","v":0}]
[]
[null,null,null,null,null,"Total Discounted Costs:",null,{"$f":"SUM(H153,H155)","v":0}]
[]
[null,null,null,null,null,"Benefit-to-Cost Ratio (B/C):",null,{"$f":"IFERROR(H147/H157,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":160}]
[null,null,null,"Based on the information provided above, the DTD calculated benefit-to-cost ratio is:",null,null,null,null,null,null,{"$f":"H159","v":0}]
[]
[null,"Modified for the Wildlife Priorizitation Study"]
[null,null,null,"Disclaimer: This Excel spreadsheet provides the assumptions, methodologies, and backup calculations for the benefit-to-cost analysis for the Wildlife Prioritization Study. The methodology follows TIGER and FASTLANE guidance. Cost are in alignment with the Traffic & Safety Engineering Branch values as calculated. This spreadsheet should be utilized for planning only."]
[null,null,null,"This research will utilize the crash values developed by the Traffic & Safety Engineering Branch."]
[null,null,null,null,null,"Fatalitiy Value",null,{"$f":"H60","v":1820600}]
[]
[null,null,null,null,null,"Injury Value (severity unknown)",null,{"$f":"H62","v":101800}]
[]
[null,null,null,null,null,"PDO cost per vehicle",null,{"$f":"H64","v":11100}]
[]
[null,null,null,"The monetized value of deer and elk are as follows:"]
[null,null,null,null,null,{"$f":"\"Value of \"&F46","v":"Value of Deer"},null,{"$f":"H102","v":2178}]
[]
[null,null,null,null,null,{"$f":"\"Value of \"&F48","v":"Value of Elk"},null,{"$f":"H104","v":2537}]
[]
[null,null,null,null,null,{"$f":"\"Value of \"&F50","v":"Value of Pronghorn"},null,{"$f":"H106","v":2106}]
[]
[null,null,null,null,null,{"$f":"\"Value of \"&F52","v":"Value of Bighorn Sheep"},null,{"$f":"H108","v":7533}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":181}]
[]
[null,null,null,null,null,"Discount Rate (i):",null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":183}]
[]
[null,null,null,null,null,"Annual Daily Traffic Growth Rate (a):",null,1.2E-2]
[]
[null,null,null,null,null,"Weighted Service Life (L):",null,{"$f":"IFERROR(IF(SUMPRODUCT($J$9:$J$14,$N$9:$N$14)/SUM($N$9:$N$14)>30,30,SUMPRODUCT($J$9:$J$14,$N$9:$N$14)/SUM($N$9:$N$14)),0)","v":0},null,null,null,"NOTE: The Traffic & Safety Engineering Branch uses a maximum useful service life of 20 years."]
[]
[null,null,null,null,null,"Year Factor (N):",null,{"$f":"YEARFRAC(I37,L37,1)","v":0},null,"The number of years of crash history reviewed/analyzed."]
[]
[null,null,null,null,"Note: The following calculations assumes that construction will begin in FY 2019 and take 1 year to complete."]
[]
[null,null,null,null,null,{"$f":"\"Predicted Fatal Crash Counts\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (F):\"","v":"Predicted Fatal Crash Counts (F):"},null,{"$f":"IFERROR(($H$40*(1+H185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted Injury Crash Counts\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (I):\"","v":"Predicted Injury Crash Counts (I):"},null,{"$f":"IFERROR(($H$42*(1+H185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted PDO Crash Counts\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (P):\"","v":"Predicted PDO Crash Counts (P):"},null,{"$f":"IFERROR(($H$44*(1+H185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F46&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V46&\"):\"","v":"Predicted Deer Deaths (W1):"},null,{"$f":"IFERROR(($H46*(1+$H$185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F48&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V48&\"):\"","v":"Predicted Elk Deaths (W2):"},null,{"$f":"IFERROR(($H48*(1+$H$185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F50&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V50&\"):\"","v":"Predicted Pronghorn Deaths (W3):"},null,{"$f":"IFERROR(($H50*(1+$H$185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Predicted \"&F52&\" Deaths\"&IF($N$27<>\"\",\" in \"&IF($N$27=\"one (1) year\",$I$27+1,$I$27+2),\"\")&\" (W\"&V52&\"):\"","v":"Predicted Bighorn Sheep Deaths (W4):"},null,{"$f":"IFERROR(($H52*(1+$H$185)^(IF($N$27=\"one (1) year\",$I$27+1,$I$27+2)-YEAR($L$37))),0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":207}]
[null,null,null,null,null,"Undiscounted Crash Reduction Benefit (UB):",null,{"$f":"IFERROR(((1+H185)^H187-1)/H185*SUM(H193*H166*$H$34,H195*H168*$J$34,H197*H170*$L$34)/H189,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Year",0,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal Year",2019,null,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049]
[null,null,null,null,null,"Undiscounted Benefit Value of Deer & Elk (UBW):",null,{"$f":"IFERROR(((1+H185)^H187-1)/H185*SUMPRODUCT(H199:H207,H173:H181)*$L$34/H189,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UB",0,null,{"$f":"IF(AA208<=$H$187,SUM($H$166*$H$193,$H$168*$H$195,$H$170*$H$197),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Discounted Crash Reduction Benefit (DB):",null,{"$f":"IFERROR(NPV(H183,Y211:BD211)/H189,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBDE",0,null,{"$f":"IF(AA208<=$H$187,SUM($H$173*$H$199,$H$175*$H$201),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"Discounted Benefit Value of Deer & Elk (DBW):",null,{"$f":"IFERROR(NPV(H183,Y212:BD212)/H189,0)","v":0}]
[]
[null,null,null,null,null,"Discounted Residual Cost:",null,{"$f":"IFERROR(SUM(EA11:EA14),0)","v":0}]
[]
[null,null,null,null,null,"Total Discounted Benefit:",null,{"$f":"SUM(H212,H214,H216)","v":0}]
[]
[null,null,null,null,null,"Undiscounted Construction Costs (UC):",null,{"$f":"E21","v":0}]
[]
[null,null,null,null,null,"Undiscounted Maintenance Costs (UM):",null,{"$f":"E23","v":0}]
[]
[null,null,null,null,null,"Discounted Construction Costs (DC):",null,{"$f":"IF(N27=\"one (1) year\",H220/(1+H183)^1,SUM(H220/2/(1+H183)^1,H220/2/(1+H183)^2))","v":0}]
[]
[null,null,null,null,null,"Discounted Maintenance Costs (DM):",null,{"$f":"IFERROR(SUM(BF11:BF14),0)","v":0}]
[]
[null,null,null,null,null,"Total Discounted Costs:",null,{"$f":"SUM(H224,H226)","v":0}]
[]
[null,null,null,null,null,"Benefit-to-Cost Ratio (B/C):",null,{"$f":"IFERROR(H218/H228,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":231}]
[null,null,null,"Based on the information provided in above, the calculated benefit-to-cost ratio is:",null,null,null,null,null,null,{"$f":"H230","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":235}]

{"sheet":"Costs & Service Life","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[26,1,26,8],[10,3,11,3],[10,4,11,4],[10,7,11,7],[10,8,11,8],[1,1,1,8],[5,1,5,8],[7,1,7,8],[9,1,9,8],[13,1,13,8]]}
[null,"Generalized Costs & Service Life for Wildlife-Highway Mitgation Components"]
[null,"Disclaimer: The cost estimates shown here include structure costs only. Roadway costs and other related items (e.g. right-of-way, utilities, traffic control, etc.) are not included at this time."]
[]
[null,"Mitigation Item","Unit Cost","Source (i.e. project)","Year Completed","Service Life","Alternate \nUnit Cost","Source of Alternate Unit Cost","Notes"]
[]
[null,"Overpass Structures (includes excavation, footings, backfill, headwalls, wingwalls, and items directly related to the overpass structure)"]
[null,"Arch or Bridge Overpass",225,"Kenny Auge, R5 estimator",2018,75,191,"SH 9 overpass total structure cost was $1,260,012.50 for 100'W x 66'L x 24'H; constructed in 2015/16.","Includes turn key installation.\nA 100'W x 64'L structure would cost $1,440,000.\nIncreased cost estimate from $200 by ~3% per year to account for increased costs."]
[null,"Underpass Structures (includes excavation, footings, backfill, headwalls, wingwalls, and items directly related to the underpass structure)"]
[null,"Bridge or Large Arch Underpass",225,"Kenny Auge, R5 estimator",2018,75,194.52,"Based on the concrete slab and girder bridge  from the 2016 Cost Data Book. SH 9 underpasses total structure cost was $728,135 for 42'W x 66'L x 14'H ($271/ft2); constructed in 2015 & 2016.","Includes turn key installation.\nA 42'W x 64'L structure would cost $604,800.\nIncrease cost estimate from $200 by ~3% per year to account for increased costs since 2015/16 (pers. comm. Kenny Auge)"]
[null,"Wildlife Exclusion Fence"]
[null,"Fencing per lane mile",98900,"SH 9 Grand County",2016,20,141334.72,"C-470; constructed in 2017","Includes fencing, posts, and braces. Does not include fence end treatments (e.g. Cellular geogrid or riprap), seeding, nor mulching."]
[null,"Fencing per linear feet",9.4,null,null,20,13.38]
[null,"16' Driveway Swing Gate",1200,"US 550 Colona",null,20,2050,"SH 9 - special"]
[null,"Deer Guards"]
[null,"16' Wide Flat Bar",34000,"SH 9 Grand County",2016,20]
[null,"20' Wide Flat Bar",40000,"SH 9 Grand County",2016,20]
[null,"24' Wide Flat Bar",45000,"SH 9 Grand County",2016,20,35700,"I-70 Wildlife Fence Eagle Co. - may not include end and brace"]
[null,"28' Wide Flat Bar",50000,"SH 9 Grand County",2016,20]
[null,"32' Wide Flat Bar",56000,"SH 9 Grand County",2016,20]
[null,"40' Wide Flat Bar",68000,"SH 9 Grand County",2016,20]
[null,"16' Wide Round Bar",40000,"Justin Kuhn, R3",2016,20]
[null,"20' Wide Round Bar",46200,"SH 9 Grand County",2016,20]
[null,"24' Wide Round Bar",51000,"SH 9 Grand County",2016,20]
[null,"28' Wide Round Bar",55000,"SH 9 Grand County",2016,20]
[null,"32' Wide Round Bar",62000,"Justin Kuhn, R3",2016,20]
[null,"40' Wide Round Bar",74000,"Justin Kuhn, R3",2016,20]
[null,"Escape Ramp"]
[null,"3:1 with Fence",13378,"SH 9 Grand County",2016,20,8085.86,"C-470. Including seeding and mulching costs per ramp is $11,398.85. $8,173 on US 160."]

{"sheet":"Effectiveness (CRF)","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[5,1,5,4]]}
[null,"Wildlife Mitigation Effectiveness"]
[null,"Disclaimer: The crash reduction factors provided in this Excel spreadsheet are used to calculate the benefit-to-cost analysis for the Western Slope wild animal research project. These factors may or may not be used for benefit-to-cost calculations for grant and safety funding applications."]
[]
[null,"Mitigation Item & Target Specifics","Average Effectiveness in Reducing WVC","Source","Notes"]
[]
[null,"Structure Mitigation (e.g. wildlife crossing structures and fencing)"]
[null,"Wildlife Crossing Structures and Countinuous Fencing.",0.87,"Average effectiveness of structures with fencing based on Kintsch et al. 2021 (deer & elk, CO, 92%); Sawyer et al. 2016 (deer & pronghorn, WY, 81%); Gagnon et al. 2015 (elk, AZ, 97%); Clevenger and Barrueto 2014 (ungulates, Banff CA, 88%); Gagnon et al. 2013 (bighorn Sheep, AZ, 82%); Sawyer et al. 2012 (mule deer, WY, 81%); Dodd et al. 2007 (elk, AZ, 87%).","Includes escape ramps, deer guards, and small culverts or culvert shelves."]
[null,"Wildlife Fencing added as a retrofit to an existing structure.",0.87,"Average effectiveness of structures with fencing based on Kintsch et al. 2021 (deer & elk, CO, 92%); Sawyer et al. 2016 (deer & pronghorn, WY, 81%); Gagnon et al. 2015 (elk, AZ, 97%); Clevenger and Barrueto 2014 (ungulates, Banff CA, 88%); Gagnon et al. 2013 (bighorn Sheep, AZ, 82%); Sawyer et al. 2012 (mule deer, WY, 81%); Dodd et al. 2007 (elk, AZ, 87%).","Includes escape ramps, deer guards, and small culverts or culvert shelves."]
[null,"Crossing structures with a short segment of fencing.",0.52700000000000002,"Huijser et al. 2016 (US 93 North; Bio. Con.)","Less than or equal to 5 km."]

{"sheet":"MISC","index":3,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Improvement Type"]
[null,"Arch or Bridge Overpass"]
[null,"Bridge or Large Arch Underpass"]
[null,"Fencing per lane mile"]
[null,"Fencing per linear feet"]
[null,"16' Driveway Swing Gate"]
[null,"16' Wide Flat Bar"]
[null,"20' Wide Flat Bar"]
[null,"24' Wide Flat Bar"]
[null,"28' Wide Flat Bar"]
[null,"32' Wide Flat Bar"]
[null,"40' Wide Flat Bar"]
[null,"16' Wide Round Bar"]
[null,"20' Wide Round Bar"]
[null,"24' Wide Round Bar"]
[null,"28' Wide Round Bar"]
[null,"32' Wide Round Bar"]
[null,"40' Wide Round Bar"]
[null,"3:1 with Fence"]